package com.huatai.manage.vo;

import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModelProperty;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import lombok.experimental.Accessors;

import java.time.LocalDateTime;

/**
 * @ClassName TbTrialSubjectVo
 * @Description TODO
 * @Author @luoxc
 * @Date 2023/4/5 11:19
 * @Version 1.0
 */
@Data
@AllArgsConstructor
@NoArgsConstructor
@Accessors(chain = true)
public class TbTrialSubjectVo {

	@ApiModelProperty(value = "对象id")
	private String subjectId;

	@ApiModelProperty(value = "对象名称")
	private String subjectName;

	@ApiModelProperty(value = "ws地址")
	private String wsUrl;

	// --------model----------
	@ApiModelProperty(value = "模型id")
	private String modelId;

	@ApiModelProperty(value = "模型名称")
	private String modelName;

	@ApiModelProperty(value = "模型类型")
	private String modelType;

	@ApiModelProperty(value = "模型地址")
	private String modelUrl;

	// --------lable----------
	@ApiModelProperty(value = "标签id")
	private String labelId;

	@ApiModelProperty(value = "标签名称")
	private String labelName;

	// --------effectName----------
	@ApiModelProperty(value = "特效Id")
	private String effectId;

	@ApiModelProperty(value = "特效名称")
	private String effectName;

	// --------topic----------
	@ApiModelProperty(value = "主题id")
	private String topicId;

	@ApiModelProperty(value = "主题队列")
	private String topicQueue;

	@ApiModelProperty(value = "主题名称")
	private String topicName;

	@ApiModelProperty(value = "模型轨迹")
	private String modelLocus;

	@ApiModelProperty(value = "模型参数（长、宽、高）")
	private String modelParameter;

	@ApiModelProperty(value = "备注")
	private String remark;

	@ApiModelProperty(value = "状态")
	private String state;

	@ApiModelProperty(value = "创建时间")
	@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
	private LocalDateTime createTime;

	@ApiModelProperty(value = "更新时间")
	@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
	private LocalDateTime updateTime;


		/*SELECT
	ttsd.subject_id,
	ttsd.subject_name,
	ttsd.ws_url,
	ttm.model_id,
	ttm.model_name,
	ttm.model_type,
	ttm.model_url,
	ttl.label_id,
	ttl.label_name,
	tse.effect_id,
	tse.effect_name,
	tmt.topic_id,
	tmt.topic_name,
	ttsd.state,
	ttsd.remark,
	ttsd.create_time,
	ttsd.update_time

FROM
	tb_trial_subject_dd ttsd
	LEFT JOIN tb_trial_model ttm ON ttsd.model_id = ttm.model_id
	LEFT JOIN tb_trial_label ttl ON ttsd.label_id = ttl.label_id
	LEFT JOIN tb_special_effect tse ON ttsd.effect_id = tse.effect_id
	LEFT JOIN tb_message_topic tmt ON ttsd.topic_id = tmt.topic_id
	WHERE ttsd.subject_id = '6174E264D309433B96B952658E2DC3CD'*/
}
